﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ESRPDataSetContact" targetNamespace="http://tempuri.org/ESRPDataSetContact.xsd" xmlns:mstns="http://tempuri.org/ESRPDataSetContact.xsd" xmlns="http://tempuri.org/ESRPDataSetContact.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ESRPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ESRPConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Fares.Properties.Settings.GlobalReference.Default.ESRPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContactTableAdapter" GeneratorDataComponentClassName="ContactTableAdapter" Name="Contact" UserDataComponentName="ContactTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Contact] WHERE (([IDContact] = @Original_IDContact) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Prenume = 1 AND [Prenume] IS NULL) OR ([Prenume] = @Original_Prenume)) AND ((@IsNull_IDTipContact = 1 AND [IDTipContact] IS NULL) OR ([IDTipContact] = @Original_IDTipContact)) AND ((@IsNull_CNP = 1 AND [CNP] IS NULL) OR ([CNP] = @Original_CNP)) AND ((@IsNull_StareCivila = 1 AND [StareCivila] IS NULL) OR ([StareCivila] = @Original_StareCivila)) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)) AND ((@IsNull_Departament = 1 AND [Departament] IS NULL) OR ([Departament] = @Original_Departament)) AND ((@IsNull_TipAI = 1 AND [TipAI] IS NULL) OR ([TipAI] = @Original_TipAI)) AND ((@IsNull_SerieAI = 1 AND [SerieAI] IS NULL) OR ([SerieAI] = @Original_SerieAI)) AND ((@IsNull_NumarAI = 1 AND [NumarAI] IS NULL) OR ([NumarAI] = @Original_NumarAI)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prenume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StareCivila" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Departament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerieAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumarAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Contact] ([Nume], [Prenume], [IDTipContact], [CNP], [StareCivila], [Functie], [Departament], [TipAI], [SerieAI], [NumarAI], [IDPartener]) VALUES (@Nume, @Prenume, @IDTipContact, @CNP, @StareCivila, @Functie, @Departament, @TipAI, @SerieAI, @NumarAI, @IDPartener);
SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM Contact WHERE (IDContact = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM dbo.Contact</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Contact] SET [Nume] = @Nume, [Prenume] = @Prenume, [IDTipContact] = @IDTipContact, [CNP] = @CNP, [StareCivila] = @StareCivila, [Functie] = @Functie, [Departament] = @Departament, [TipAI] = @TipAI, [SerieAI] = @SerieAI, [NumarAI] = @NumarAI, [IDPartener] = @IDPartener WHERE (([IDContact] = @Original_IDContact) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Prenume = 1 AND [Prenume] IS NULL) OR ([Prenume] = @Original_Prenume)) AND ((@IsNull_IDTipContact = 1 AND [IDTipContact] IS NULL) OR ([IDTipContact] = @Original_IDTipContact)) AND ((@IsNull_CNP = 1 AND [CNP] IS NULL) OR ([CNP] = @Original_CNP)) AND ((@IsNull_StareCivila = 1 AND [StareCivila] IS NULL) OR ([StareCivila] = @Original_StareCivila)) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)) AND ((@IsNull_Departament = 1 AND [Departament] IS NULL) OR ([Departament] = @Original_Departament)) AND ((@IsNull_TipAI = 1 AND [TipAI] IS NULL) OR ([TipAI] = @Original_TipAI)) AND ((@IsNull_SerieAI = 1 AND [SerieAI] IS NULL) OR ([SerieAI] = @Original_SerieAI)) AND ((@IsNull_NumarAI = 1 AND [NumarAI] IS NULL) OR ([NumarAI] = @Original_NumarAI)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)));
SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM Contact WHERE (IDContact = @IDContact)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prenume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StareCivila" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Departament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerieAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumarAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDContact" ColumnName="IDContact" DataSourceName="ESRP.dbo.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDContact" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDContact" DataSetColumn="IDContact" />
              <Mapping SourceColumn="Nume" DataSetColumn="Nume" />
              <Mapping SourceColumn="Prenume" DataSetColumn="Prenume" />
              <Mapping SourceColumn="IDTipContact" DataSetColumn="IDTipContact" />
              <Mapping SourceColumn="CNP" DataSetColumn="CNP" />
              <Mapping SourceColumn="StareCivila" DataSetColumn="StareCivila" />
              <Mapping SourceColumn="Functie" DataSetColumn="Functie" />
              <Mapping SourceColumn="Departament" DataSetColumn="Departament" />
              <Mapping SourceColumn="TipAI" DataSetColumn="TipAI" />
              <Mapping SourceColumn="SerieAI" DataSetColumn="SerieAI" />
              <Mapping SourceColumn="NumarAI" DataSetColumn="NumarAI" />
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MijloaceTransportTableAdapter" GeneratorDataComponentClassName="MijloaceTransportTableAdapter" Name="MijloaceTransport" UserDataComponentName="MijloaceTransportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.MijloaceTransport" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[MijloaceTransport] WHERE (([IDMijlocTransport] = @Original_IDMijlocTransport) AND ([Denumire] = @Original_Denumire) AND ([NrInmatriculare] = @Original_NrInmatriculare) AND ([IDPartener] = @Original_IDPartener))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MijloaceTransport] ([Denumire], [NrInmatriculare], [IDPartener]) VALUES (@Denumire, @NrInmatriculare, @IDPartener);
SELECT IDMijlocTransport, Denumire, NrInmatriculare, IDPartener FROM MijloaceTransport WHERE (IDMijlocTransport = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDMijlocTransport, Denumire, NrInmatriculare, IDPartener FROM dbo.MijloaceTransport</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[MijloaceTransport] SET [Denumire] = @Denumire, [NrInmatriculare] = @NrInmatriculare, [IDPartener] = @IDPartener WHERE (([IDMijlocTransport] = @Original_IDMijlocTransport) AND ([Denumire] = @Original_Denumire) AND ([NrInmatriculare] = @Original_NrInmatriculare) AND ([IDPartener] = @Original_IDPartener));
SELECT IDMijlocTransport, Denumire, NrInmatriculare, IDPartener FROM MijloaceTransport WHERE (IDMijlocTransport = @IDMijlocTransport)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDMijlocTransport" ColumnName="IDMijlocTransport" DataSourceName="ESRP.dbo.MijloaceTransport" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDMijlocTransport" DataSetColumn="IDMijlocTransport" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="NrInmatriculare" DataSetColumn="NrInmatriculare" />
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ESRPDataSetContact" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ESRPDataSetContact" msprop:Generator_UserDSName="ESRPDataSetContact">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Contact" msprop:Generator_TableClassName="ContactDataTable" msprop:Generator_TableVarName="tableContact" msprop:Generator_TablePropName="Contact" msprop:Generator_RowDeletingName="ContactRowDeleting" msprop:Generator_RowChangingName="ContactRowChanging" msprop:Generator_RowEvHandlerName="ContactRowChangeEventHandler" msprop:Generator_RowDeletedName="ContactRowDeleted" msprop:Generator_UserTableName="Contact" msprop:Generator_RowChangedName="ContactRowChanged" msprop:Generator_RowEvArgName="ContactRowChangeEvent" msprop:Generator_RowClassName="ContactRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDContact" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDContact" msprop:Generator_ColumnPropNameInRow="IDContact" msprop:Generator_ColumnPropNameInTable="IDContactColumn" msprop:Generator_UserColumnName="IDContact" type="xs:int" />
              <xs:element name="Nume" msprop:Generator_ColumnVarNameInTable="columnNume" msprop:Generator_ColumnPropNameInRow="Nume" msprop:Generator_ColumnPropNameInTable="NumeColumn" msprop:Generator_UserColumnName="Nume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prenume" msprop:Generator_ColumnVarNameInTable="columnPrenume" msprop:Generator_ColumnPropNameInRow="Prenume" msprop:Generator_ColumnPropNameInTable="PrenumeColumn" msprop:Generator_UserColumnName="Prenume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTipContact" msprop:Generator_ColumnVarNameInTable="columnIDTipContact" msprop:Generator_ColumnPropNameInRow="IDTipContact" msprop:Generator_ColumnPropNameInTable="IDTipContactColumn" msprop:Generator_UserColumnName="IDTipContact" type="xs:short" minOccurs="0" />
              <xs:element name="CNP" msprop:Generator_ColumnVarNameInTable="columnCNP" msprop:Generator_ColumnPropNameInRow="CNP" msprop:Generator_ColumnPropNameInTable="CNPColumn" msprop:Generator_UserColumnName="CNP" type="xs:decimal" minOccurs="0" />
              <xs:element name="StareCivila" msprop:Generator_ColumnVarNameInTable="columnStareCivila" msprop:Generator_ColumnPropNameInRow="StareCivila" msprop:Generator_ColumnPropNameInTable="StareCivilaColumn" msprop:Generator_UserColumnName="StareCivila" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Functie" msprop:Generator_ColumnVarNameInTable="columnFunctie" msprop:Generator_ColumnPropNameInRow="Functie" msprop:Generator_ColumnPropNameInTable="FunctieColumn" msprop:Generator_UserColumnName="Functie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Departament" msprop:Generator_ColumnVarNameInTable="columnDepartament" msprop:Generator_ColumnPropNameInRow="Departament" msprop:Generator_ColumnPropNameInTable="DepartamentColumn" msprop:Generator_UserColumnName="Departament" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipAI" msprop:Generator_ColumnVarNameInTable="columnTipAI" msprop:Generator_ColumnPropNameInRow="TipAI" msprop:Generator_ColumnPropNameInTable="TipAIColumn" msprop:Generator_UserColumnName="TipAI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerieAI" msprop:Generator_ColumnVarNameInTable="columnSerieAI" msprop:Generator_ColumnPropNameInRow="SerieAI" msprop:Generator_ColumnPropNameInTable="SerieAIColumn" msprop:Generator_UserColumnName="SerieAI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumarAI" msprop:Generator_ColumnVarNameInTable="columnNumarAI" msprop:Generator_ColumnPropNameInRow="NumarAI" msprop:Generator_ColumnPropNameInTable="NumarAIColumn" msprop:Generator_UserColumnName="NumarAI" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDPartener" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MijloaceTransport" msprop:Generator_TableClassName="MijloaceTransportDataTable" msprop:Generator_TableVarName="tableMijloaceTransport" msprop:Generator_TablePropName="MijloaceTransport" msprop:Generator_RowDeletingName="MijloaceTransportRowDeleting" msprop:Generator_RowChangingName="MijloaceTransportRowChanging" msprop:Generator_RowEvHandlerName="MijloaceTransportRowChangeEventHandler" msprop:Generator_RowDeletedName="MijloaceTransportRowDeleted" msprop:Generator_UserTableName="MijloaceTransport" msprop:Generator_RowChangedName="MijloaceTransportRowChanged" msprop:Generator_RowEvArgName="MijloaceTransportRowChangeEvent" msprop:Generator_RowClassName="MijloaceTransportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDMijlocTransport" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDMijlocTransport" msprop:Generator_ColumnPropNameInRow="IDMijlocTransport" msprop:Generator_ColumnPropNameInTable="IDMijlocTransportColumn" msprop:Generator_UserColumnName="IDMijlocTransport" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NrInmatriculare" msprop:Generator_ColumnVarNameInTable="columnNrInmatriculare" msprop:Generator_ColumnPropNameInRow="NrInmatriculare" msprop:Generator_ColumnPropNameInTable="NrInmatriculareColumn" msprop:Generator_UserColumnName="NrInmatriculare">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPartener" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Contact" />
      <xs:field xpath="mstns:IDContact" />
    </xs:unique>
    <xs:unique name="MijloaceTransport_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MijloaceTransport" />
      <xs:field xpath="mstns:IDMijlocTransport" />
    </xs:unique>
  </xs:element>
</xs:schema>